﻿CREATE TABLE [dbo].[JobLocation] (
    [JobId]      UNIQUEIDENTIFIER NOT NULL,
    [LocationId] INT              NOT NULL,
    CONSTRAINT [PK_JobLocation] PRIMARY KEY CLUSTERED ([JobId] ASC, [LocationId] ASC),
    CONSTRAINT [FK_JobLocation_Job] FOREIGN KEY ([JobId]) REFERENCES [dbo].[Job] ([JobId]),
    CONSTRAINT [FK_JobLocation_Location] FOREIGN KEY ([LocationId]) REFERENCES [dbo].[Location] ([LocationId])
);

